package com.marvels.loanapply.api;

import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.marvels.common.exception.MarvelsBusinessException;
import com.marvels.loanapply.dto.ChannelCostDTO;
import com.marvels.loanapply.dto.CheckBillDTO;
import com.marvels.loanapply.dto.FlowStatisticsDTO;
/**
 * 对账管理 相关业务
 * @author 刘琴
 * 2018年10月10日
 */
public interface LoanapplyCheckBillApi {
	
	/**
	 * 查询流量统计
	 * @param dto
	 * @return
	 */
	public List<FlowStatisticsDTO> selectFlowStatistics(CheckBillDTO dto) throws MarvelsBusinessException;
	
	
	/**
	 * 查询渠道成本
	 * @param dto
	 * @return
	 */
	public List<ChannelCostDTO> channelCost(CheckBillDTO dto) throws MarvelsBusinessException;
	
	
	/**
	 * 渠道成本下载
	 * @param dto
	 * @return
	 * @throws MarvelsBusinessException
	 */
	public HSSFWorkbook channelCostDown(CheckBillDTO dto) throws MarvelsBusinessException;
	
	/**
	 * 下载流量统计
	 * @param dto
	 * @return
	 * @throws MarvelsBusinessException
	 */
	public HSSFWorkbook findFlowStatisticsExcelWorkbook(CheckBillDTO dto) throws MarvelsBusinessException;
	/**
	 * 根据用户名模糊查询获取相关user_id
	 * @param userName
	 * @return
	 */
	public String selectUserIdByName(String userName);
	/**
	 * 根据用户手机获取用户姓名
	 * @param mobile
	 * @return
	 */
	public String selectUserNameByPhone(String mobile);
	/**
	 * 根据用户手机获取用户姓名 方法1
	 * @param mobile
	 * @return
	 */
	public Map<String,String> selectUserNameByPhone1(String mobiles);
	/**
	 * 获取该时间段内指定续贷用户
	 * @param startDate
	 * @param endDate
	 * @return
	 */
	public String selectContinueLoanUser(String startDate,String endDate);
	/**
	 * 将财务的放款时间同步到ac_loan_apply_info表中
	 * @param loanId
	 * @return
	 */
	public String synchroMoneyHandOutTime(String loanId);
	
}
